Education and Services Hub

Course Title:

Course ID:

050224 0701 950ESH

Course Dates :

05/Feb/2024

 To

09/Feb/2024

Course Duration :

5

Course Location:

London

United Kingdom

Course Fees GBP £ :

Primary Price

£4,555.99

VAT may vary depending on the country where the course or workshop is held

Course Fees USD $:

Advisory Price

$5,829.09

VAT may vary depending on the country where the course or workshop is held

Course Category:

NGO Programmes

Employalibelity Pathway (NT)

Course Certified By:

* Professional Training and CPD Programs
* Executive Diploma Certificate
* Executive Masters Certificate

* ESHub CPD
* LondonUni
* Others

United Kingdom

Please Note : Your £250.00 Deposit will be deducted from the total invoice Amount.
To commence the registration process for your training course, please follow the link provided and proceed with; Upon successful payment, we will promptly contact you to finalize your enrollment and issue a confirmation of your guaranteed placement.

Course Information

Introduction

Welcome to the Advanced Microsoft Excel Training Course designed specifically for non-governmental organizations (NGOs).
In today's digital age, Excel proficiency is a crucial skill for maximizing organizational efficiency and data management.
This comprehensive 5-day course will delve into advanced Excel techniques tailored to the unique needs of NGOs, equipping participants with the tools and knowledge to enhance their data analysis, reporting, and decision-making capabilities.
Each day of the course will consist of hands-on exercises, interactive discussions, and practical demonstrations to reinforce learning and ensure participants can immediately apply their newfound skills in their respective roles within NGOs.

Objectives

• Provide in-depth training on advanced Excel features and functions relevant to NGO operations.
• Enhance participants' ability to manage and analyse data effectively using Excel.
• Empower participants to create dynamic reports, dashboards, and data visualizations.
• Explore methods for optimizing workflow and increasing productivity through Excel automation.
• Foster a collaborative learning environment where participants can share insights and best practices for Excel usage within the NGO sector.

Who Should Attend?

This course is ideal for professionals working in non-governmental organizations (NGOs) who already possess basic to intermediate Excel skills and are seeking to elevate their proficiency to an advanced level.
Participants may include program managers, data analysts, finance officers, project coordinators, and any staff members responsible for data management, analysis, or reporting within their organizations.

Training Method

• Pre-assessment
• Live group instruction
• Use of real-world examples, case studies and exercises
• Interactive participation and discussion
• Power point presentation, LCD and flip chart
• Group activities and tests
• Each participant receives a 7” Tablet containing a copy of the presentation, slides and handouts
• Post-assessment

Program Support

This program is supported by:
* Interactive discussions
* Role-play
* Case studies and highlight the techniques available to the participants.

Daily Agenda

The course agenda will be as follows:
• Technical Session 08.30-10.00 am
• Coffee Break 10.00-10.15 am
• Technical Session 10.15-12.15 noon
• Coffee Break 12.15-12.45 pm
• Technical Session 12.45-02.30 pm
• Course Ends 02.30 pm

Please Note : Your £250.00 Deposit will be deducted from the total invoice Amount.
To commence the registration process for your training course, please follow the link provided and proceed with; Upon successful payment, we will promptly contact you to finalize your enrollment and issue a confirmation of your guaranteed placement.

Week 1

Day 1:
Excel Fundamentals Review
• Recap of essential Excel functions and formulas
• Data validation techniques for ensuring data integrity
• Introduction to advanced data manipulation tools: PivotTables and PivotCharts

Day 2:
Advanced Data Analysis
• Exploring advanced functions: INDEX, MATCH, and OFFSET
• Performing complex data analysis using array formulas
• Utilizing Excel's built-in statistical functions for data analysis

Day 3:
Advanced Reporting Techniques
• Creating dynamic reports with Excel's Power Query and Power Pivot
• Designing interactive dashboards for data visualization
• Incorporating advanced charting techniques for impactful visual presentations

Day 4:
Excel Automation and Efficiency
• Introduction to macros and VBA (Visual Basic for Applications)
• Automating repetitive tasks using Excel macros
• Streamlining workflow with Excel's automation features

Day 5:
Collaboration and Best Practices
• Collaborative data editing and sharing using Excel Online and SharePoint
• Best practices for data organization and management within NGOs
• Case studies and group discussions on Excel usage in real-world NGO scenarios

Please Note : Your £250.00 Deposit will be deducted from the total invoice Amount.
To commence the registration process for your training course, please follow the link provided and proceed with; Upon successful payment, we will promptly contact you to finalize your enrollment and issue a confirmation of your guaranteed placement.